package org.example.score.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

@Mapper
public interface WeightMapper {

    @Select("SELECT * FROM pd_zhibiao_weight_value WHERE qzlx = '综合'  and user_id=0 ")
    public List<Map<String, Object>> getWeight();

    @Select("SELECT * FROM pd_zhibiao_weight_value WHERE qzlx = #{syxwlx}")
    public List<Map<String, Object>> getWeightBy(String syxwlx);


    @Select("select column_name,column_comment from information_schema.columns where table_name = 'pd_zhibiao_weight_value' ")
    List<Map<String, Object>> getColumnNames();


    @Update("UPDATE pd_zhibiao_weight_value SET zbqz=#{zbqz} WHERE zbh = #{zbh} and qzlx = #{qzlx}  ")
    public int update1(Double zbqz, String zbh, String qzlx);

}
